﻿USE QASK

-- insert into posttype
INSERT INTO posttype VALUES(1, 'Question')
INSERT INTO posttype VALUES(2, 'Answer')

-- insert into timezone
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('International Date Line West', '(GMT-12:00)', -12, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Midway Island', '(GMT-11:00)', -11, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Samoa', '(GMT-11:00)', -11, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Hawaii', '(GMT-10:00)', -10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Alaska', '(GMT-09:00)', -9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Pacific Time (US & Canada)', '(GMT-08:00)', -8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Tijuana', '(GMT-08:00)', -8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Arizona', '(GMT-07:00)', -7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Mountain Time (US & Canada)', '(GMT-07:00)', -7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Chihuahua', '(GMT-07:00)', -7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('La Paz', '(GMT-07:00)', -7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Mazatlan', '(GMT-07:00)', -7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Central Time (US & Canada)', '(GMT-06:00)', -6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Central America', '(GMT-06:00)', -6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Guadalajara', '(GMT-06:00)', -6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Mexico City', '(GMT-06:00)', -6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Monterrey', '(GMT-06:00)', -6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Saskatchewan', '(GMT-06:00)', -6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Eastern Time (US & Canada)', '(GMT-05:00)', -5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Indiana (East)', '(GMT-05:00)', -5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Bogota', '(GMT-05:00)', -5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Lima', '(GMT-05:00)', -5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Quito', '(GMT-05:00)', -5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Atlantic Time (Canada)', '(GMT-04:00)', -4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Caracas', '(GMT-04:00)', -4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('La Paz', '(GMT-04:00)', -4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Santiago', '(GMT-04:00)', -4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Newfoundland', '(GMT-03:30)', -3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Brasilia', '(GMT-03:00)', -3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Buenos Aires', '(GMT-03:00)', -3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Georgetown', '(GMT-03:00)', -3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Greenland', '(GMT-03:00)', -3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Mid-Atlantic', '(GMT-02:00)', -2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Azores', '(GMT-01:00)', -1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Cape Verde Is.', '(GMT-01:00)', -1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Casablanca', '(GMT)', 0, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Dublin', '(GMT)', 0, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Edinburgh', '(GMT)', 0, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Lisbon', '(GMT)', 0, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('London', '(GMT)', 0, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Monrovia', '(GMT)', 0, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Amsterdam', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Belgrade', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Berlin', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Bern', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Bratislava', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Brussels', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Budapest', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Copenhagen', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Ljubljana', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Madrid', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Paris', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Prague', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Rome', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Sarajevo', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Skopje', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Stockholm', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Vienna', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Warsaw', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('West Central Africa', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Zagreb', '(GMT+01:00)', 1, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Athens', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Bucharest', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Cairo', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Harare', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Helsinki', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Istanbul', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Jerusalem', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Kyev', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Minsk', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Pretoria', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Riga', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Sofia', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Tallinn', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Vilnius', '(GMT+02:00)', 2, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Baghdad', '(GMT+03:00)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Kuwait', '(GMT+03:00)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Moscow', '(GMT+03:00)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Nairobi', '(GMT+03:00)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Riyadh', '(GMT+03:00)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('St. Petersburg', '(GMT+03:00)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Volgograd', '(GMT+03:00)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Tehran', '(GMT+03:30)', 3, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Abu Dhabi', '(GMT+04:00)', 4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Baku', '(GMT+04:00)', 4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Muscat', '(GMT+04:00)', 4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Tbilisi', '(GMT+04:00)', 4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Yerevan', '(GMT+04:00)', 4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Kabul', '(GMT+04:30)', 4, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Ekaterinburg', '(GMT+05:00)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Islamabad', '(GMT+05:00)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Karachi', '(GMT+05:00)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Tashkent', '(GMT+05:00)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Chennai', '(GMT+05:30)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Kolkata', '(GMT+05:30)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Mumbai', '(GMT+05:30)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('New Delhi', '(GMT+05:30)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Kathmandu', '(GMT+05:45)', 5, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Almaty', '(GMT+06:00)', 6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Astana', '(GMT+06:00)', 6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Dhaka', '(GMT+06:00)', 6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Novosibirsk', '(GMT+06:00)', 6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Sri Jayawardenepura', '(GMT+06:00)', 6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Rangoon', '(GMT+06:30)', 6, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Bangkok', '(GMT+07:00)', 7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Hanoi', '(GMT+07:00)', 7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Jakarta', '(GMT+07:00)', 7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Krasnoyarsk', '(GMT+07:00)', 7, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Beijing', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Chongqing', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Hong Kong', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Irkutsk', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Kuala Lumpur', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Perth', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Singapore', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Taipei', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Ulaan Bataar', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Urumqi', '(GMT+08:00)', 8, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Osaka', '(GMT+09:00)', 9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Sapporo', '(GMT+09:00)', 9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Seoul', '(GMT+09:00)', 9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Tokyo', '(GMT+09:00)', 9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Yakutsk', '(GMT+09:00)', 9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Adelaide', '(GMT+09:30)', 9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Darwin', '(GMT+09:30)', 9, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Brisbane', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Canberra', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Guam', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Hobart', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Melbourne', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Port Moresby', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Sydney', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Vladivostok', '(GMT+10:00)', 10, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Magadan', '(GMT+11:00)', 11, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('New Caledonia', '(GMT+11:00)', 11, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Solomon Is.', '(GMT+11:00)', 11, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Auckland', '(GMT+12:00)', 12, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Fiji', '(GMT+12:00)', 12, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Kamchatka', '(GMT+12:00)', 12, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Marshall Is.', '(GMT+12:00)', 12, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Wellington', '(GMT+12:00)', 12, 0)
INSERT INTO TimeZones (Location, GMT, OffSet, IsDST) VALUES ('Nuku''alofa', '(GMT+13:00)', 13, 0)